C - Interview Questions and Answers for 'Jibe development services' - 3 question(s) found - Order By Newest Q1. Write a SQL to find max salary by Dept SQL
Ans. SELECT MAX(SALARY),DEPT FROM EMPLOYEE GROUP BY DEPT Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve Asked in 1 Companies Related Questions What are Inner , Outer , Left and Right Joins in SQL ? What is JDBC? Describe the steps needed to execute a SQL query using JDBC. What are temp tables ? What is a self Join and give an example of a self Join ? Do you like Native SQL Apis like JDBC or JPA / Hibernate ? Is there any schema in mongo DB ? Difference between Inner and Outer Join ? What is a Cursor ? Does SQL allow null values ? Can we use it within Where clause ? Write an SQL to find all records having all upper case alphanumeric characters in a field ? Q2. What is a composite primary key and foreign key ? Database
Ans. The combination of values from multiple columns in the composite primary key must be unique for each row in the table. Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve Asked in 1 Companies Related Questions Difference between == and .equals() ? Why is String immutable in Java ? Explain the scenerios to choose between String , StringBuilder and StringBuffer ? What are the difference between composition and inheritance in Java? Explain OOPs What is a Lambda Expression ? What's its use ? Why Char array is preferred over String for storing password? What are different ways to create String Object? Explain. Does garbage collection guarantee that a program will not run out of memory? What is the difference between final, finally and finalize() ? Q3. What is ado.net ? C#
This question was recently asked at 'jibe development services'.This question is still unanswered. Can you please provide an answer. Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve Asked in 1 Companies Related Questions Difference between == and .equals() ? Why is String immutable in Java ? Explain the scenerios to choose between String , StringBuilder and StringBuffer ? What are the difference between composition and inheritance in Java? Explain OOPs What is a Lambda Expression ? What's its use ? Why Char array is preferred over String for storing password? What are different ways to create String Object? Explain. Does garbage collection guarantee that a program will not run out of memory? What is the difference between final, finally and finalize() ?
More than 3000 questions in repository.
Related Questions